﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="物资库存明细表.aspx.cs" Inherits="syc.Store.报表.物资库存明细表" %>
<html>
<head runat="server">
    <title></title>
    <style  type="text/css">
     tr{line-height:20px;}
       .table2 td
        {
            border:.5pt solid  windowtext;	      
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    
    <script type="text/javascript" language="javascript" src="/common.js"></script>
    <div id="wintop" class="wintop">物资库存明细</div>
        <asp:Panel ID="Panel3" runat="server" CssClass="panel">
            年份：<asp:DropDownList ID="Year0" runat="server" 
                onselectedindexchanged="Year0_SelectedIndexChanged">               
                <asp:ListItem>2010</asp:ListItem>
                <asp:ListItem>2011</asp:ListItem>
                <asp:ListItem>2012</asp:ListItem>
                <asp:ListItem>2013</asp:ListItem>
                <asp:ListItem>2014</asp:ListItem>
                <asp:ListItem>2015</asp:ListItem>
                <asp:ListItem>2016</asp:ListItem>
                <asp:ListItem>2017</asp:ListItem>
            </asp:DropDownList>
            &nbsp;月份：<asp:DropDownList ID="Month0" runat="server" AutoPostBack="True" 
                onselectedindexchanged="Month0_SelectedIndexChanged">
                <asp:ListItem>1</asp:ListItem>
                <asp:ListItem>2</asp:ListItem>
                <asp:ListItem>3</asp:ListItem>
                <asp:ListItem>4</asp:ListItem>
                <asp:ListItem>5</asp:ListItem>
                <asp:ListItem>6</asp:ListItem>
                <asp:ListItem>7</asp:ListItem>
                <asp:ListItem>8</asp:ListItem>
                <asp:ListItem>9</asp:ListItem>
                <asp:ListItem>10</asp:ListItem>
                <asp:ListItem>11</asp:ListItem>
                <asp:ListItem>12</asp:ListItem>
            </asp:DropDownList>
      <asp:Button ID="Button_Query"
            runat="server" Text="查看报表" CssClass="button" UseSubmitBehavior="true" onclick="Button_Query_Click"  Visible="false"
             />
             <asp:Button ID="Button_Save" runat="server" CssClass="button" 
            onclick="Button_Save_Click" Text="导 出" UseSubmitBehavior="False" />
        </asp:Panel>
      <asp:Panel ID="Panel2" runat="server" CssClass="panel2">
            <asp:Label ID="Message" runat="server" Text="·准备就绪" CssClass="prompt"></asp:Label>
        </asp:Panel>
    <div align="center" style="font-size:21px">
        <br />
        <%=this.Year0.SelectedValue %>年<%=this.Month0.SelectedValue %> 月份物资库存明细表</div>
    <div>
    
<table width="1000px" border="0" cellspacing="0">
  <tr>
    <td>填报单位：物料中心</td>
    <td colspan="5">&nbsp;</td>
    <td colspan="2"><div align="center"><%=DateTime.Now.ToString("yyyy年MM月dd日") %></div></td>
  </tr>
</table>
 <table class="table2" width="1000px" border="1"  cellspacing="0"   style="font-size:14px;border-color:Black; border-width:2px;" >
  <tr>
    <td rowspan="2"><div align="center">物资名称</div></td>
    <td rowspan="2"><div align="center">规格</div></td>
    <td rowspan="2"><div align="center">单位</div></td>
    <td rowspan="2"><div align="center">上期结存</div></td>
    <td colspan="6"><div align="center">本期收入</div></td>
    <td colspan="6"><div align="center">本期发出</div></td>
    <td rowspan="2"><div align="center">本期结存</div></td>
  </tr>
  <tr>
    <td><div align="center">一分厂</div></td>
    <td><div align="center">二分厂</div></td>
    <td><div align="center">三分厂</div></td>
    <td><div align="center">四分厂</div></td>
	
    <td><div align="center">五分厂</div></td>
    <td><div align="center">合计</div></td>
    <td><div align="center">一分厂</div></td>
    <td><div align="center">二分厂</div></td>
    <td><div align="center">三分厂</div></td>
    <td><div align="center">四分厂</div></td>
	
    <td><div align="center">五分厂</div></td>
    <td><div align="center">合计</div></td>
  </tr>
  <tr>
    <td><div align="center">原料：</div></td>
    <td colspan="16"><div align="center"></div>      </td>
  </tr>
  <tr>
    <td><div align="center">其中：套管</div></td>
    <td><div align="center">139.7×7.72</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=套管光管期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=套管光管本期收入%></div></div></td>
    <td><div align="center"><%=-一分厂套管料本期发出%></td>
    <td><div align="center"><%=-二分厂套管料本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-套管光管本期发出%></div></td>
    <td><div align="center"><%=套管料本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">待处理套管</div></td>
    <td><div align="center">139.7×7.72</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=待处理套管期末库存 - 待处理套管本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-一分厂待处理套管本期发出 %></div></td>
    <td><div align="center"><%=-二分厂待处理套管本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-待处理套管本期发出%></div></td>
    <td><div align="center"><%=待处理套管期末库存%></div></td>
  </tr>
  <tr>
    <td><div align="center">套管接箍</div></td>
    <td><div align="center">153.67×14.5</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=套管接箍光管期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=套管接箍光管本期收入%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-三分厂套管接箍料本期发出 %></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-套管接箍光管本期发出 %></div></td>
    <td><div align="center"><%=套管接箍料本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">油管</div></td>
    <td><div align="center">73.02×5.51</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=油管光管期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=油管光管本期收入%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-二分厂油管料本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-五分厂油管料本期发出%></div></td>
    <td><div align="center"><%=-油管光管本期发出%></div></td>
	<td><div align="center"><%=油管料本期结存 %></div></td>
  </tr>
  <tr>
    <td><div align="center">待处理油管</div></td>
    <td><div align="center">73.02×5.51</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=待处理油管期末库存 - 待处理油管本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-二分厂待处理油管本期发出 %></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"><%=-五分厂待处理油管本期发出 %></div></td>
    <td><div align="center"><%=-待处理油管本期发出 %></div></td>
    <td><div align="center"><%=待处理油管期末库存%></div></td>
	
  </tr>
  <tr>
    <td><div align="center">油管接箍</div></td>
    <td><div align="center">88.9×12.5</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=油管接箍光管期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=油管接箍光管本期收入%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-三分厂油管接箍料本期发出%></div></td>
    <td ><div align="center"></div></td>
	<td ><div align="center"></div></td>
    <td><div align="center"><%=-油管接箍光管本期发出 %></div></td>
    <td><div align="center"><%=油管接箍料本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">聚乙烯</div></td>
    <td><div align="center"></div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=聚乙烯期初库存 %></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td ><div align="center"></div></td>
	<td ><div align="center"></div></td>
    <td><div align="center"><%=聚乙烯本期入库%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-聚乙烯本期出库%></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-聚乙烯本期出库%></div></td>
    <td><div align="center"><%=聚乙烯期末库存 %></div></td>
  </tr>
  <tr>
    <td><div align="center">钢带</div></td>
    <td><div align="center"></div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=钢带期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=钢带本期入库%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-钢带本期出库%></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-钢带本期出库%></div></td>
    <td><div align="center"><%= 钢带期末库存%></div></td>
  </tr>
  <tr>
    <td><div align="center">辅料：</div></td>
    <td colspan="16"><div align="center"></div>      </td>
  </tr>
  <tr>
    <td><div align="center">其中：保护器</div></td>
    <td><div align="center">2-7/8（油管)</div></td>
    <td><div align="center">套</div></td>
    <td><div align="center"><%=油管螺纹保护环期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=油管螺纹保护环本期入库%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-油管螺纹保护环本期出库 %></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-油管螺纹保护环本期出库 %></div></td>
    <td><div align="center"><%=油管螺纹保护环期末库存%></div></td>
  </tr>
  <tr>
    <td><div align="center">保护器</div></td>
    <td><div align="center">5-1/2（套管）</div></td>
    <td><div align="center">套</div></td>
    <td><div align="center"><%=套管螺纹保护环期初库存 %></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=套管螺纹保护环本期入库%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=-油管螺纹保护环本期出库%></div></td>
    <td><div align="center"></div></td>
    <td ><div align="center"></div></td>
	<td ><div align="center"></div></td>
    <td><div align="center"><%=-油管螺纹保护环本期出库%></div></td>
    <td><div align="center"><%=油管螺纹保护环期末库存%></div></td>
  </tr>
  <tr>
    <td><div align="center">保护器</div></td>
    <td><div align="center">自产</div></td>
    <td><div align="center">套</div></td>
    <td><div align="center"><%=自产螺纹保护环期初库存 %></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=自产螺纹保护环本期入库 %></div></td>
    <td><div align="center"><%=-一分厂自产保护器本期发出%></div></td>
    <td><div align="center"><%=-二分厂自产保护器本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-自产螺纹保护环本期出库%></div></td>
    <td><div align="center"><%=自产螺纹保护环期末库存%></div></td>
  </tr>
  <tr>
    <td><div align="center">半成品：</div></td>
    <td colspan="16"><div align="center"></div>      </td>
  </tr>
  <tr>
    <td><div align="center">成品套管接箍</div></td>
    <td><div align="center"></div></td>
    <td><div align="center">支</div></td>
    <td><div align="center"><%=成品接箍期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=成品套管接箍本期收入%></div></td>
    <td><div align="center"><%=-一分厂成品套管接箍本期发出 %></div></td>
    <td><div align="center"><%=-二分厂成品套管接箍本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-成品套管接箍本期发出%></div></td>
    <td><div align="center"><%=成品接箍期初库存 + 成品套管接箍本期收入 - 成品套管接箍本期发出%></div></td>
  </tr>
   <tr>
    <td><div align="center">成品N80Q套管接箍</div></td>
    <td><div align="center"></div></td>
    <td><div align="center">支</div></td>
    <td><div align="center"><%=成品N80接箍期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=成品N80套管接箍本期收入%></div></td>
    <td><div align="center"><%=-一分厂成品N80套管接箍本期发出%></div></td>
    <td><div align="center"><%=-二分厂成品N80套管接箍本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-(成品N80套管接箍本期发出)%></div></td>
    <td><div align="center"><%=成品N80接箍期初库存 + 成品N80套管接箍本期收入-成品N80套管接箍本期发出%></div></td>
  </tr>
  <tr>
    <td><div align="center">自产套管接箍</div></td>
    <td><div align="center"></div></td>
    <td><div align="center">支</div></td>
    <td><div align="center"><%=自产套管接箍期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=自产套管接箍本期收入%></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=自产套管接箍本期收入%></div></td>
    <td><div align="center"><%=-一分厂自产套管接箍本期发出%></div></td>
    <td><div align="center"><%=-二分厂自产套管接箍本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-自产套管接箍本期发出%></div></td>
    <td><div align="center"><%=自产套管接箍本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">自产油管接箍</div></td>
    <td><div align="center"></div></td>
    <td><div align="center">支</div></td>
    <td><div align="center"><%=自产油管接箍期初库存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=自产油管接箍本期收入%></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=自产油管接箍本期收入%></div></td>
    <td><div align="center"><%=-一分厂自产油管接箍本期发出 %></div></td>
    <td><div align="center"><%=-二分厂自产油管接箍本期发出%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=-自产油管接箍本期发出%></div></td>
    <td><div align="center"><%=自产油管接箍本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">成品：</div></td>
    <td colspan="16"><div align="center"></div>      </td>
  </tr>
  <tr>
    <td><div align="center">其中：套管(J55)</div></td>
    <td><div align="center">5-1/2</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=套管上期结存%></div></td>
    <td><div align="center"><%=y1tao%></div></td>
    <td><div align="center"><%=y2tao%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=y1tao + y2tao%></div></td>
    <td><div align="center"><%=y1taoc %></div></td>
    <td><div align="center"><%=y2taoc%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=y1taoc + y2taoc%></div></td>
    <td><div align="center"><%=套管本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">油管(J55)</div></td>
    <td><div align="center">2-7/8</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=油管上期结存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=y2you%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"><%=y5you%></div></td>
    <td><div align="center"><%=y2you+y5you %></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=y2youc%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"><%=y5youc%></div></td>
    <td><div align="center"><%=y2youc+y5youc%></div></td>
    <td><div align="center"><%=油管本期结存%></div></td>
  </tr>
   <tr>
    <td><div align="center">其中：套管(N80)</div></td>
    <td><div align="center">5-1/2</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=套管N80上期结存%></div></td>
    <td><div align="center"><%=y1tao%></div></td>
    <td><div align="center"><%=y2tao%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=y1taoN80 + y2taoN80%></div></td>
    <td><div align="center"><%=y1taocN80 %></div></td>
    <td><div align="center"><%=y2taocN80%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"></div></td>
    <td><div align="center"><%=y1taocN80 + y2taocN80%></div></td>
    <td><div align="center"><%=套管N80本期结存%></div></td>
  </tr>
  <tr>
    <td><div align="center">油管(N80)</div></td>
    <td><div align="center">2-7/8</div></td>
    <td><div align="center">t</div></td>
    <td><div align="center"><%=油管N80上期结存%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=y2youN80%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"><%=y5youN80%></div></td>
    <td><div align="center"><%=y2youN80 + y5youN80%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"><%=y2youcN80%></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
	<td><div align="center"><%=y5youcN80%></div></td>
    <td><div align="center"><%=y2youcN80 + y5youcN80%></div></td>
    <td><div align="center"><%=油管N80本期结存%></div></td>
  </tr>
</table>
    </div>
    </form>
</body>
</html>
